SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 53320: Selecting the Analysis and Data tab displays the error "The Result Set type is invalid for the requested operation. SQL Error Code 187"

DetailsHotfixAboutRate It

In the SAS® Risk Dimensions® Project Editor, if you select Model ► Analysis and Data, the following Java exception can occur:

==================== MESSAGE KEY ======================== The Result Set type is invalid for the requested operation. SQL Error Code 187 =========================================================== com.sas.rio.MVASQLException: The Result Set type is invalid for the requested operation. at com.sas.rio.MVAResultSet.absolute(MVAResultSet.java:537) at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sas.analytics.jdbc.ResultSetProxy.invokeMethod(ResultSetProxy.java:77) at com.sas.analytics.jdbc.ResultSetProxy.invoke(ResultSetProxy.java:53) at com.sun.proxy.$Proxy2.absolute(Unknown Source) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getIndexInfo(INameLists.java:1166) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getIndexInfo(INameLists.java:1044) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getIndexInfo(INameLists.java:1001) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNamesDescFromDataset(INameLists.java:962) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNamesL(INameLists.java:919) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNames(INameLists.java:900) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNames(INameLists.java:894) at com.sas.analytics.risk.c_midtier.models.iom.INameLists.getPortfolioStatisticNames(INameLists.java:589) at com.sas.analytics.risk.c_midtier.models.iom.IEnvironmentRiskObjects.getPortfolioStatisticsNames(IEnvironmentRiskObjects.java:1432) at com.sas.analytics.risk.c_swing.components.ProjectEditorPrompt.createAnalysisTab(ProjectEditorPrompt.java:810) at com.sas.analytics.risk.c_swing.components.ProjectEditorPrompt.createAnalysisAndDataTab(ProjectEditorPrompt.java:2405)

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Risk Dimensions Enterprise EditionWindows 7 Enterprise x646.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Enterprise 32 bit6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 Std6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 R2 Std6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 R2 Datacenter6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 2012 Datacenter6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 2008 for x646.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 2008 R26.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows Server 20086.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Pro 32-bit6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Pro6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Enterprise x646.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8.1 Enterprise 32-bit6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8 Pro x646.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8 Pro 32-bit6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8 Enterprise x646.2_M16.39.4 TS1M19.4 TS1M1
Microsoft Windows 8 Enterprise 32-bit6.2_M16.39.4 TS1M19.4 TS1M1
Microsoft® Windows® for x646.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Home Premium 32 bit6.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Home Premium x646.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Professional 32 bit6.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Professional x646.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Ultimate 32 bit6.2_M16.39.4 TS1M19.4 TS1M1
Windows 7 Ultimate x646.2_M16.39.4 TS1M19.4 TS1M1
64-bit Enabled AIX6.2_M16.39.4 TS1M19.4 TS1M1
64-bit Enabled Solaris6.2_M16.39.4 TS1M19.4 TS1M1
HP-UX IPF6.2_M16.39.4 TS1M19.4 TS1M1
Linux for x646.2_M16.39.4 TS1M19.4 TS1M1
Solaris for x646.2_M16.39.4 TS1M19.4 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.